Viewing 15 posts - 766 through 780 (of 1,271 total)
Sometimes (not necessarily this time) it is easier or more efficient to take the result set of your current query, and then perform additional processing on it. 2 ways to...
February 8, 2007 at 4:17 pm
Objects like views, functions, and procedures that include the Create as part of the object will be scripted out by EM exactly as originally written.
So if the user creates a...
February 7, 2007 at 11:36 am
That query only appears to represent secodns because you put a 1 second delay in there. Comment out the delay and you will see that the timestamp increments each time...
February 5, 2007 at 11:42 am
Post the schema of the table (script the create table statement).
February 2, 2007 at 12:51 pm
If you use a column with date values in it, you can do the query you are trying to do:
Declare
@test-2 Table
My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]
February 2, 2007 at 12:33 pm
Don't count on the alerts for anything critical. Instead, create a job that checks the status of replication and handles failures accordingly. For my merge replication, I have a job...
February 2, 2007 at 12:25 pm
It can also be done with just T-SQL.
Declare
@cmdshell nvarchar(500), @Path nvarchar(200)
February 2, 2007 at 12:16 pm
You need to rewrite the query to be efficient. You can do that whole thing without a cursor:
Declare
@MatterID bigint
Declare
@EntityID int
Declare
My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url]
February 2, 2007 at 11:43 am
Definitely #1.
February 2, 2007 at 11:30 am
Can you modify the tables? If you add a column to the tables indicating the database it is in (or better yet an integer value that references a table with...
February 2, 2007 at 11:27 am
Just be aware that neither scptxfr.exe nor SQLDMO are aware of the new datatypes and such in SQL 2005. SQLDMO will work with SQL 2005 (for backwards compatibilty) but it...
February 1, 2007 at 8:24 am
If you do that, just be aware that if someone uses sp_rename to rename a stored procedure, the text of the procedure doesn't get changed. Therefore, it is possible that...
January 31, 2007 at 11:46 am
You have to use SQLDMO (this is what EM uses). There is no T-SQL way to do this without writing the entire process yourself.
Look up "Script Method" in Books Online...
January 31, 2007 at 10:41 am
Actually, it's not the fault of Excel's driver. It's the fault of the ISAM that Excel uses. This problem preceeds Excel.
January 31, 2007 at 12:20 am
I found this post to be very humerous in the forum talking about the fix:
This tool can be run while the database is up and can analyze the entire database....
January 30, 2007 at 12:52 pm
Viewing 15 posts - 766 through 780 (of 1,271 total)