Viewing 15 posts - 8,941 through 8,955 (of 9,641 total)
Apparently MS thinks using linked servers is more secure than opendatasource as they have it disabled by default.:D
Personally, I prefer using linked servers. The only caveat is...
March 27, 2008 at 9:08 am
Check out DDL triggers in BOL. This allows you to do exactly what you are looking for.
March 27, 2008 at 9:03 am
You can use the OPTION(Recompile) query hint. From BOL:
RECOMPILE
Instructs the SQL Server 2005 Database Engine to discard the plan generated for the query after it executes, forcing the query...
March 27, 2008 at 9:02 am
Do you mean the identity field? If that is what you mean it would depend on the datatype you use. For example, int, the most commonly used indentity...
March 27, 2008 at 8:58 am
What are you connecting to? The default timeout on the oledb source is 0 which means infinite.
March 27, 2008 at 8:50 am
In my experience you really can't trust the preview tab in visual studio. A better way to test reports is to set your configuration to DebugLocal which will open...
March 27, 2008 at 8:45 am
Robert,
I have looked at the plans and the executed statements. If you look at the executed statements they are 2 different statements because the one using the US defaults...
March 27, 2008 at 8:40 am
Why not store the data in a table and then it just becomes a straight calculation in your select? The following code would work and you would not have...
March 27, 2008 at 7:26 am
You would need to use the designer. I typically use an Execute SQL Task to truncate the destination table. Then use a Data Flow Task for creating the...
March 27, 2008 at 7:06 am
What happens if you export to PDF and then print?
Do the memo\long text fields containg special characters like carraige returns and line feeds? If they do you should try...
March 27, 2008 at 7:00 am
Michael, I don't see where the OP mentions using a stored procedure. He does mention that he is using Reporting Services.
Robert,
How are you generating the SQL?...
March 27, 2008 at 6:57 am
George Heinrich (3/26/2008)
I guess is explained my problem poorly - what I really want to know is how can you run a SP with multiple...
March 26, 2008 at 7:10 am
By default a primary key is created as the clustered index. You would need to drop the primary key, create a clustered index, and re-create the primary key as...
March 25, 2008 at 10:32 am
If all you want is to insure the rows are stored in insert order add a clustered index to the incrementing numeric column.
March 25, 2008 at 10:01 am
From BOL:
...only one null value is allowed per column.
March 25, 2008 at 9:42 am
Viewing 15 posts - 8,941 through 8,955 (of 9,641 total)