all, i have a dts package that is password protected and of course, no one knows the password. they are trying to say that it must be corrupted etc....
Satya, thanks for the article. excellent material.
all, i have a few tables that are constantly updated. these tables are replicated to a "reporting" database on a seperate server. i was told...
all, i am in a new environment and have a problem that I think is related to dependency on a datetime field. i have two tables that are joined on id...
Thanks Satya, I did find this as well. If you are familiar with C# and SQL DMO it isn't so bad. I think I had to log in to get the source. It's...
Does anyone know the easiest way to transfer linked servers from one server to another without having to manually set them up? I can't seem to...
Hello all, does anyone know if / where SQL Server stores the last date that an object was altered? ie. I created a proc 2 weeks ago and it was...
Does anyone know how to identify a data set of table names that have a column that has the identity property set? Thanks, Detroit
All, I have a messy query with alot of where clause. here is the original select @Count = count(*), @TicketTotal = sum(tbl_2.qty) /1000 from...
Hey everyone, I have a nasty replication scenario in my test and QA environment that I am trying to deal with. I have a database replication...
All, When i needed to use email notifications in the past with a sql cluster I had to "forward" events and messages to a non clustered server with a...
fellows, I have some problems!!!!!! I was given a database that is in rough shape. here are the particulars. SQL 2000 RTM. The SQL Services wouldn't...
argyle, i did specify this registry key for replication when i created the generic service to start the mssqlserverolap service in cluster admin....
All, I have sql server 2000 olap services clustered on a windows 2003 cluster. I have a project server 2003 database on this same cluster. I migrated...
Mazie, after you run your dbcc shrinkfile operations on the log file, what is the size of the .ldf file? Is the file size reduced to the original...
for everything listed, i agree to perform a full backup of the database in question. if it is a custom item here and there you can use this proc ......
if the defaults were originally accepted at installation and never changed, the log file has grown in small increments. that is very stressful to...
www.webopedia.com it's not the largest database of "computer terms" but the definitions are straight forward. cpu - central processing unit....
thanks guys. a very vast topic. these articles help.
if the drive is a mapped drive and not local you can use xp_cmdshell to call it from a unc path. you will need a share and security access to the...
Separate names with a comma.
