Viewing 15 posts - 91 through 105 (of 271 total)
Have you looked at the the CHECKSUM function and the HashBytes function (HashBytes may only be in 2005 I can't remember) anyway both these built in fucntions can be used to...
July 3, 2006 at 1:31 pm
Your problem is that when you do restore SQL server will try and restore the files to their original locations and if you go to different server with different logical...
June 28, 2006 at 2:30 pm
If you are using SQL Server 2005 MINUS in Oracle is equivalent to EXCEPT in SQL Server 2005 this is not available in SQL Server 2000.
Anyway I wouldn't use the...
June 24, 2006 at 5:53 am
The binary osrt order is case sensitive and will be why you are seeing the difference.
David
June 11, 2006 at 12:34 pm
You can't access a 2005 database server from enterprise manager but you can access a sql server 2000 db server from sql server management studio.
hth
David
June 10, 2006 at 5:01 am
Its not possible to restore just a single table.
However you could restore the backup of the database as a new database and then you use a cross database query to...
June 10, 2006 at 4:59 am
Ownership chaining still exists in SQL Server 2005 and is not replaced by execute as in sql server 2005. Exceute as just gives you another option and is very useful...
June 10, 2006 at 4:51 am
To be honest it sounds like a permissions problem i have changed the location of my tempdb using exactly the
same procedure on several occasions on live and developmenet servers in both...
June 6, 2006 at 4:39 pm
I would create a linked server if i was using sqlexpress.
You can add them by in the express management studio or by using some system stored procedures i don't...
June 6, 2006 at 10:33 am
The character data in excel will be in unicode so you can either create the character data fields in sql server as unicode or you will need to add in...
June 6, 2006 at 10:18 am
You should find that there is an outlook client installed on the sql server box.
The mail profile it uses should be setup in there just modify this profile to use...
June 6, 2006 at 5:30 am
There is one thing you may need to check first and thats the scope of your variable make sure its at a level where it can be seen in the...
June 6, 2006 at 12:37 am
To be honest the best thing to do is read the the bit in Books online about doing filegroup restores which explains what you need to do otherwise I'll just...
June 6, 2006 at 12:20 am
A couple of things if you are doing a filegroup restore I believe you have to back up tail of the log before starting the restore so that the filegroup being...
June 5, 2006 at 4:34 pm
Tempdb should be recreated each time you start the server so you should have had to move the files but you could try opening a command prompt and navigating to
C:\Program...
June 5, 2006 at 4:24 pm
Viewing 15 posts - 91 through 105 (of 271 total)