Search results for query: *

I have a Windows 2008 R2 X64 Std Edt. and SQL 2008 (Developer Edt.) SP1 server. When I open SSMS and run the following queries: exec xp_cmdshell 'dir C:\' exec xp_cmdshell 'dir F:\' exec xp_cmdshell 'dir E:\' The first two (C: and F:) work fine but the last (E:) gives the message: "The...

I have an user who's been added to the dbo role in a sql 2000 database. When using Sql Server 2005 Management Studio to create the table the table always has the name domain\login_name as the owner of the table. It doesn't make any difference if he adds the dbo to the name before he goes to...

I've written the following script to get the size, usedSpace and freeSpace of my databases. However, the results don't always match what SQL Management Studio (2005) shows. I'm sure I'm not taking something into account and any help would be appreciated. if...

Using: Microsoft SQL Server 2005 SP3 Can you move the .ldf file on the secondary database that's involved in logshipping? If so any special precautions that I need to be aware of?

I am trying to remove "question marks" (?) from a string of data. Example: SELECT REPLACE(<column_name>, '?', '') FROM <table_name> However it does not remove the question mark (?). I also tried using CHAR(63) in place of '?' and it still doesn't work. Is there something special about "?"...

I've inherited an application that calls a number of stored procedures. In quite a few of them I've been finding updates that look like the following: UPDATE tbl_name SET field_name = 'some value' FROM tbl_name WITH (NOLOCK) WHERE field_name = 'some other value' I didn't think you could use...

We are going to be moving databases from one sql 2005 server to another sql 2005 server as part of a hardware upgrade. One of the databases participates in logshipping. If I backup the database and restore it on the other server will this break logshipping? I realize I will have to redo...

I have two windows 2003 servers that are cross connected on a 10. IP/subnet 255.0.0.0 The public nic's are on a 20?.???.???.?? subnet 255.255.255.0 VPN host is 21?.??.??.??? but the error points to it being a 10. something IP. My problem is when I connect to the company VPN (cisco vpn client)...

Server OS: Windows 2003 x64 sp2 SQL Server 2005 x64 w/SP3 I have a SSIS package (ProtectionLevel:DontSaveSensitive) that has been imported to Integration Services as a file. The file has not been stored in the default location during the package creation. No problems w/the import and when I...

I am trying to take a hex value like 0x3A, 0x2f and convert it to it's ascii equivlent. I have code below that works but it needs to run inside of a function and since only other functions and extended stored procedures can be executed from within a function it is failing. The function takes a...

I have logshipping going on between two SQL 2000 Servers. On the server that contains the secondary server we are having hardware issues w/our SAN and will need to move to another SQL Server and a different storage array (not sure if this will be another SAN or maybe a DAS). My question is...

I have a new 64bit sql 2005 server w/sp3 on Windows 2003 /sp2 I am trying to attach a sql 2000 database using the following sql statements i.e. without attaching the log file. CREATE DATABASE Test ON (FILENAME = 'D:\MSSQL\Data\Test_Data.MDF') FOR ATTACH_REBUILD_LOG I receive the following...

Windows 2003 x64 sp2 SQL Server 2000 x86 sp4 I found a sql login that had been given sysadmin rights to the server. It was also an user in a number of databases as well with db_owner permissions. I removed the sysadmin rights and now whenever someone creates a data object (table, sproc...

I just completed a fresh install of SQL 2005 x64. I then downloaded service pack 3 and ran the install. When it came to selecting the components to upgrade I was unable to select the MSSQL>>>Database Service (it did find a number of components to upgrade), in fact I couldn't check or uncheck...

Not sure if this is the right place to post, if not please let me know where to go. My problem: Have a Dell Inspiron E1705 w/Windows XP sp3 installed. All drivers are up to date from Dells website. When I am at work I can plug into our network with no problems (I've used other network...

I have been battling what I believe is a memory issue and I have been trying to figure out why the page life expectancy on this server is all over the place. We are running sql 2000/sp4 on windows 2003 sp2. The server HP DL585 with 4 dual core cpu's, 48GB RAM (maxserver mem = 44GB) mirrored...

I have some data that looks like this: ID NAME COUNT PRODUCTNAME 1 Tom's Garage 5 Brakes 1 Tom's Garage 3 Tail Lights 1 Tom's Garage 3 Mufflers 1 Tom's Garage 2 Spark Plugs 1 Tom's Garage 1 Oil Filters Needs to look like this ID NAME...

I have a database that participates in logshipping. Right now the database (47.5gb) file for the Primary db is quite large and has considerable free space (24gb) . I would like to shrink the database to regain most of the free space. My question is there anything special I have to take into...

I have two servers lets call them A and B. Server A is in one domain and Server B is in another domain. I've created a local login on both servers and given it the same username and password. I've given this account access to share(s) on each server so it can read and write to the specified...

If this isn't the correct forum just let me know where to go. How can I find out which queries/stored procedures are causing table/index scans? I know I can use profiler and select scans:started and scans:Stopped but that doesn't tell me which queries/stored procedures are the cause. Thanks mk