Viewing 15 posts - 37,936 through 37,950 (of 39,757 total)
We do this with categories here at SSC.
create table Category
( categoryid int
, categoryname varchar(20)
, parentcatid int
)
insert category 1, 'SQL 2000', 0
insert category 2, 'Programming', 0
insert category...
April 4, 2002 at 1:09 pm
yes,
create view N_orders as
select *
from northwind.dbo.orders
return
create this in pubs to access northwind.
Steve Jones
April 4, 2002 at 1:06 pm
Is this a valid path on the server? THe with MOVE is to restore from a different path than that the backup was made with. This applies to different servers...
April 4, 2002 at 1:01 pm
they both will work well. The IN resolves to essentially a series of ORs
Steve Jones
April 4, 2002 at 12:59 pm
Is the problem that SQL Server sometimes runs on 5000? Is this an instance besides the default? The server network utility mentioned above allows you to limit SQL Server to...
April 4, 2002 at 9:53 am
If you don't have the need for a SAN, I'd stay away. You are spending $$ and taking chances for no reason. SANs are usually looked at for the 100s...
April 2, 2002 at 4:43 pm
Personally I use Box C as a QA box, backup/restore box A to box C, deploy code, and test. If everything is ok, then deploy code to box A and...
April 2, 2002 at 10:53 am
This is an often a debated topic. Store the .jpgs in the filesystem and the path in the db or store the image in the db. I vote for the...
April 2, 2002 at 10:46 am
You cannot do this. You need to setup a linked server to access another sql server from T-SQL.
Steve Jones
April 2, 2002 at 10:44 am
secure shell, vpn, export to file and encrypt the file and then ftp the encrypted file (or other transport).
Steve Jones
April 2, 2002 at 10:26 am
OK, I'm slightly confused, but here are some things to note.
For each SQL Server instance, there is an MSSQLServer service and a SQLAgent service. There may be others, but these...
April 2, 2002 at 10:15 am
April 2, 2002 at 10:04 am
I've thought about using a COM component and am not opposed. The thing I really like about this method is I can copy a single file (.DTS) to a SQL...
April 2, 2002 at 10:02 am
I have seen this before when the SQL Server cannot see the domain controller. It cannot authenicate the use.
Can other users connect with NT Auth? Check the server event...
April 2, 2002 at 9:58 am
If there is only one log file, you can delete it and only restore the database file. The system should create a new log file for you.
Steve Jones
April 2, 2002 at 9:55 am
Viewing 15 posts - 37,936 through 37,950 (of 39,757 total)