Search results for query: *

Hi, Here's the data in the table id value 5 546 6 566 7 566 8 587 I want to add a "delta" column that will show the change between the current data and data above, so it would show: id value delta 5 546 6 566 20 7 566 0 8 587 21 Is it possible in RS...

Hi, I need to import a couple hundred of files. From what I noticed, the files do not all have the same columns, but they all share three columns that I am interested in, ie "col1","col2", and "col3". Now I need to import these files, preferably not through dts into my table that contains the...

Hi, I can't seem find a way to add a computer column in a replicated enviroment. It's a column that's a substring([othercolumn],1,100) <data_type> DEFAULT <constant_expression> IDENTITY <seed> <increment> NOT FOR REPLICATION ROWGUIDCOL <column_constraint>

Hello, I need to (form) post to a http web page, retrieve the results and put to a table's text field. I've tried using Msxml2.XMLHTTP object, but it either fails to post data or returns Exceptions. (no useful description) Any suggestions, samples, or alternatives would be greatly...

Hi, I am aware of master..xp_dirtree. How would I retrieve a list of all files in a folder? I've been playing around with Scripting.FileSystemObject Folder Object which returns a collection of Object File. Unfortunately I don't know how to get at each of the File(s) to retrieve Name...

Hi, From what I understand, SQL Server will write in 8kB chunks. Is it possible to change this figure? For example if I have a database where a lot of data gets updated in bulk, it might make sense to write more bytes in each page.

Hi, We have made a decision to drop the Crystal Enterprise and replace with Microsoft's Reporting Services. I'd like to make this thread and information source for others aiming at the migration process. Please post any information, tool or utilities that can help accomplish the task, Thank you.

Hi, I've looked through the BOL and I can't find a view I could use to check if the Relationship option 'Enforce relationship for INSERTs and UPDATEs' is checked for all the tables? (And then list all the tables that do not have the option 'on') I have a bunch of tables and I don't want to go...

Is it possible to decrypt sql server 2000 stored procedures? I've found this script: http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14369 but it doesn't work for me... any ideas?

Anyone's got one?

Hi I am new to replication and I have a few simple questions. My goal is to setup a database where I can store a history of all records that were deleted/updated/inserted with out the overhead of triggers on the production server. In other words I want to create a database on another box...

Hi, I'm trying to setup publication on one of the databases through SQL Server Enterprise manager. After I press finish on the wizzard, the server goes through the steps and it fails on &quot;Creating Publication&quot;. The error I'm getting is: Error 0: This server has been disconnected...

Hi, We are changing the server for which the report data will be accessed. Is it possible to loop through all the reports on the server and change the login settings automatically? BTW, I am using CE 9.

Hi, I am using CE 9.0 and we are distributing this report as an email attachement. Can I include the date of the report in the Subject of the email?

Hi, We are using Crystal version 9.0. For some reason when I include the '%SI_VIEWER_URL%' in the text body of email message the link to the report does not go through! Any idea why it is happening?

Can someone point me to an article from a legitimate source(such as microsoft) that proves that xp_SendMail cannot be used to send html content? I can find people talking about it on many groups but can't find a legitimate source.

Syntax sp_OASetProperty objecttoken, propertyname, newvalue [ , index... ] Is there a 4k character limit the number of characters that can be passed in as the new value? I want to send out emails by passing in the email string into the parameter, what are my other solutions?

Hi, I need to get information on which fields on a table are primary keys, using sql script. Which system tables/information schema views should I look into? Thanks.

I am performing a large insert followed by a large delete. I want to truncate the transaction log right after. How to backup transaction log programatically (I believe this will truncate)? Are dbcc shrinkfile and dbcc shrinkdatabase my only options? I don't want to use shrink file, becuse...

Hi All, I need to copy table structures from one database to another. The copies will contain additional fields. Only table names, column names and column data types must be copied (no indexes, fk, pk, etc...). I need to build the 'create table ...' statement and then execute it on another...