Search results for query: *

Hi, Once I started thinking about this, I realized I don't really know how to do this. Basically, we have a disaster recovery server that will be kept up-to-date via a 3rd party log-shipping tool. But what about non-user database objects, such as 1.) jobs 2.) operators 3.) linked servers...

SELECT 'Name', 'Rows', 'Reserved', 'Data', 'IndexSize', 'Unused' UNION SELECT Name, Rows, Reserved, Data, IndexSize, Unused FROM ##TableSpaceUsed ORDER BY CAST(Rows AS INT) Error: Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'Rows'. TRYING TO OUTPUT COLUMN NAME + RESULT SET...

Hi, SQL Server 2000 I need a way to email a formatted result set from a Select statement. What is the best/simplest way to to this? SSIS? Thanks

Hi, Besides the fact that log shipping is available with Standard edition w/ 2005, are there any other significant advantages of 2005 log shipping vs 2000 log shipping? Not having used either, I am interested to know other's opinions. Thanks much

Hi, I need a way to change the run time of a job that normally runs at 4:45 am each day. The catch is, I only want to change the run time on 2 days of the month (which will be dynamically determined each month); so it's not like I know the days before hand. Help, is there a good way to do...

Hi, I need to query that can calculate the date of the 3rd Friday of every month. Any ideas? Thanks much

Hi, I am looking for alternative ways to copy and restore a database backup from SF to NY. I tried using robocopy to copy the backup, but it was very very slow and would have taken about 16 hours to complete. That doesn't work. I am asking for people's input and suggestion for how to best...

I need some help thinking this out... I have a staging table that gets loaded with data from a file using ssis. The file is a rolling history file, in that every day's current file not only contains that day's data, but also data for the previous days in the month. So for example, if today is...

Hi, I have a table that has some rows with duplicate data. I want to find the duplicate data, based on 5 columns. That is, some of the rows have the same values in these 5 columns. How can I write this query? Thanks

Hello, I am trying to solve a disagreement with a coworker. Does running DBCC REINDEX on a heap table have any effect? My position is no, it does not. A run of DBCC SHOWCONTIG before and after shows that the statistics do NOT change whatsoever. However, his position is that by running DBCC...

Hi, I am running this under my windows login in ssms, which is administrator on the server: declare @cmd varchar(100) set @cmd = 'dir \\networkpath\file' exec xp_cmdshell @cmd ERROR: The network path was not found. Is this a permissions problem? Why can't xp_cmdshell see the unc path? Thanks

Hi, When I run c:\runScript.bat from a cmd line, it works fine. But when I try to run from mgmt studio: exec master..xp_cmdshell 'c:\runScript.bat' Why am I getting this error message: 'c:\runScript.bat' is not recognized as an internal or external command, operable program or batch file...

Hi, When I try to run sp_msforeachdb on SQL Server 2005 (to call scptxfr.exe for each database on a server), it locks up completely and never finishes my scripting. I don't think the problem is with scptxfr.exe per se, because I don't have a problem when running this in general, just when I...

When I run this from Mgmt Studio: EXEC master..xp_cmdshell 'DEL C:\mypath\*.master.*' GO It gives this message: Could Not Find C:\mypath\*.master.* Runs fine from my job... What is the problem here? Thanks

Hi, I am trying to find out what the following file extensions created by scptxfr.exe are: .EXT .LGN .RUL (also .DP1 & .DP2 - although I suspect these are drop scripts, but mine are all empty so hard to know) Does anyone have a clue? Thanks

Hi, I have a nightly process that copies a backup from one server to another then restores it by overwriting the existing database. I don't drop it first. However, when I check the newly restored db's properties in Managment Studio, it has an old "create date". How come it doesn't show the...

Hi, I am familiar with setting up xp_cmdshell proxy accounts. However, I have concerns with security. That is, if then map a user to master and grant them execute on xp_cmdshell, that user effective has os permissions, which I may or may not want them to have. Is there a workaround to this...

Hi, We do full backups only, no log file backups. One of our log files reached the 100GB mark. I realized this is my fault because I wasn't truncating & shrinking the log file on a regular basis. But I'm just curious as to why this log got so big? Is it only because I neglected to back it up...

Hi, DELETE FROM table1 tr JOIN table2 trs ON tr.BusinessDate = trs.BusinessDate error next to "tr" - what am i doing wrong?

Hi, I'm still trying to understnad the difference between a backup with INIT vs. NOINIT. I know the BOL says that NOINIT appends, and INIT overwrites backup sets, but I'm trying to understand why you would want one or the other?? That is, what is the advantage of appending vs. not appending...