Viewing 15 topics - 270,256 through 270,270 (of 270,961 total)
I am new to SQL server 7 and have just made a small database, the largest table at the moment is ar…
18 years, 6 months ago
I have a web content management system that pushes a transactional replication from a staging serve…
By: Andy Warren
I would like to change the pk on several published tables from clustered to nonclustered for better…
is it possible to select data from a table not specified by compile-time in T-SQL? SOmething li…
A trivial task that is bugging me.
I have a list of Keys that a multi-select dropdown in the…
Do you know how to use SQL to make an 'indirection'. You remember in the C language, how you can t…
How can I determine which user has a row level lock against a specified record?
I have just started a new role as an SQL DBA and I'm currently in a huge learing curve. We have bui…
When I run a distributed query (a query that uses a linked server), I get the following
error in qu…
I need to be able to detect that a program is running from a sql job/dts and post the run times (be…
I've MSSQL Server 7.0 SP3 on WinNT 4 SP6. In database was one big datafile (m.mdf),…
I am testing a security model implementation, but I've hit a roadblock. A stored procedure is owne…
SQL Server registration failed because of the connection failure displayed below.
General Network …
By: Steve Jones - SSC Editor
can anyone help.
I am new to the SQL Server.
I need to input data into a column with the PK (Pri…
When I right-click the databases node in EM and select All Tasks / Restore Database it seems to eit…