Page 89
Index
‹
Archive Home
‹
SQL Server Archive
‹
Page 89
Archive
84
85
86
87
88
89
90
91
92
93
94
view full version:
back to formated view
1:
Assignment of @owner_login_name for scripted jobs
2:
finding child relationship
3:
Foreign Key Constraint
4:
SQL Mail / Outlook 2003
5:
I cannot drop a table
6:
Query master file and two entries of related file into a single re
7:
How to give a developer empty copy of a DB?
8:
backup files to local PC
9:
How to create column in existing table
10:
ODBC failing - Driver outdated
11:
Import excel sheet to database
12:
How to get Windows process id for sqlservr.exe?
13:
sp_addlinkedsrvlogin syntax for "not be made"
14:
who is dbo?
15:
Create a dimension/lookup table
16:
BCP API & max_errors
17:
Delete Triggers....
18:
Time-outs connecting to SQL box
19:
Trigger to block negative values in a column
20:
Can I run sql server on a peer to peer network?
21:
Connect to SQL using Data Control
22:
SQL QUERY HELP
23:
Updateable view from two tables
24:
Just wondering...
25:
Full Text Indexing
26:
Need Opinions on Updating Large tables
27:
Error Message requires explanation please
28:
How can I see the network drives (for backup or else) in SQL Serve
29:
Works in QA not as SQL job
30:
conditions within WHERE clause
31:
identity column
32:
Administrative Tasks
33:
SQL 2000 and Query Analyzer?
34:
Trigger Question
35:
Multilingual database design
36:
Help w/ a SQL Query
37:
Increase nvarchar field value like a num
38:
showing system objects.
39:
Check if a table has a specific column
40:
Executing Stored Procedure with result set
41:
Drop an unnamed primary key....
42:
Big Database needs pruning
43:
Should I use table locking?
44:
Backups of Logs - Growing way, way out of control & Need Assistanc
45:
Database Engine Tuning Advisor Wont Suggest Any Changes :-)
46:
SQL Server error 1934
47:
SQL Syntax Help
48:
What to monitor on daily basis
49:
cluster.exe /list
50:
update query- What am i doing wrong
51:
adding a file in a file group; how to "use" it?
52:
XML Question
53:
SQL 2005 Create/Alter Procedure Question
54:
Upgrading a box to Win 2k3 with SQL 7 on the box..
55:
sp problem...
56:
Should I use Table Variable or Temp Table in this case ?
57:
MAX from multiple columns?
58:
index optimization
59:
DTS TRansform Task giving inconsistent results.
60:
Question on Backup/Restore
61:
TempLog growth
62:
JDBC client - CURSOR as OUT parameter -supported ?
63:
Adventure Works DB
64:
drop or rename a table problem
65:
SQL Server 2005 Error 5195
66:
trigger - new.value
67:
Multipls cursors help
68:
Group by/ Having question
69:
Problem
70:
SQL SERVER 2000 SP2 (version 8.00.0733) or SP3(version 8.00.0765)
71:
test, please ignore
72:
Enterprise Manager vs. Management Studio
73:
SQL 7 - Text Field - Case Insensitive Search - How?
74:
Programatically find out stored procedures properties
75:
Some assistance with MS SQL injection and PHP please
76:
Security Role
77:
Conditional Where
78:
is it possible to number the records?
79:
Insert statement hangs (linked server)
80:
PL-SQL to T-SQL trigger conv
81:
Where are jobs and SP stored?
82:
grant permission to all objects
83:
SQL Server on Pentium IV
84:
showplan output for current running statements
85:
Finding Missing Records
86:
Help obtain a window of rows from a table
87:
How to truncate DB logs in SQL 2000.
88:
No Error, No Processing...
89:
IF EXISTS before DELETE
90:
Maintenance Plan and Ghost SPIDs
91:
SQL Server Raplication
92:
Number of users for SQL Server 2000 Personal Edition
93:
min
94:
2000 to 2005 upgrade question
95:
Replacing Nulls
96:
Function and Procedure Parameter Defaults
97:
Resize DB in SQL 7
98:
IDENTITY SELECT
99:
yukon
100:
restore: EXCEPTION_ACCESS_VIOLATION c0000005 (17052)
101:
counting child rows?
102:
Zipping the big database.
103:
SPROC help
104:
Need some help dealing with Binary Column
105:
Restore Log Files with Move
106:
Problem adding new record with CusorLocation=adUseClient
107:
ODBC Connection using Alternate windows credentials
108:
Date format
109:
Your thoughts???
110:
Limit selection to row x to row y ?
111:
Modifying records
112:
Curious performance issue when running a query
113:
Revisit: DISTINCT Query Returning Duplicate Results
114:
Replace NULL with "-" using Trigger
115:
SQL Personal Edition
116:
howto update from another table
117:
Finding text string with a list of jobs..
118:
Moving the Database
119:
SQl 2005 version numbers
120:
best way to get a count on a left joined table?
121:
Concatenate Uniqueidentifier
122:
3 tier setup
123:
XP_CMDSHELL
124:
Dynamitc From in Select?
125:
Create schema if not exists - problems
126:
Urgent - Hotfix Question
127:
udf for ranking returned rows
128:
dblib bulk copy ( empty string VS <NULL>)
129:
Fail to attach to MDF file
130:
Retrieving Coulmns in an Index from System Tables
131:
Linked Server SP takes time
132:
Switch of exceptions in SQL Server 2005
133:
Error 242, Severity : 16, State : 3.
134:
Aggregate BitWise functions
135:
Need help with my stored proc
136:
How to CREATE THIS VIEW???
137:
Insert into Problem
138:
MS SQL Srv 2000 and extended stored procedures
139:
Need help understanding DBCC SHOW_STATISTICS
140:
indexes
141:
How to list all user that have permission on database?
142:
"select rows @start through @end" -- how to do it?
143:
Bug Details: Unexpected behavior of Ident_Current() over SQL2005 SP1 x64
144:
Inserting a datetime variable in a Raiserror command
145:
How to take big raw text in SP as a paremeter!...............
146:
Select with inner query
147:
Search for defaults in table DDL?
148:
Check if Delete ran in a trigger
149:
SQL Server performance condition alert
150:
backup / trn file size.
151:
Sample Database Designs ?
152:
Sp_Sproc_Columns
153:
Why ADO.NET?
154:
Redeploying CLR UDT
155:
Too much unused space a performance issue?
156:
Stored Proc - Do a split
157:
sqldumpexceptionhandler
158:
Statistics question
159:
Maintenace Plan Transaction Log Back Up is Stuck ?
160:
Odd SQL Server Stored Procedure Question
161:
problem in SQL SERVER adding large size field to a table
162:
how to automate a SQL database restore
163:
Standard Database Schemas?
164:
Calculate New 'Unique' Records Each Day
165:
getting list of users who have access to db
166:
SQL passing parameters/forms from Frontpage 2003
167:
NULL Value in Aggregate Function
168:
Deletin db
169:
Temp Tables
170:
server explorer create stored procs - what version of IDE?
171:
Linked vs. Remote Servers
172:
sp_executesql help
173:
Query Analyzer
174:
Move DTS Package
175:
Rights issue
176:
scheduled backup question
177:
Replication gone bad
178:
Reformat Text Field
179:
Expanding Hierarchies problem
180:
Northeast Training Recommendations
181:
Null in tables
182:
finding out how many items are tied to a primary key
183:
UCS-2 and Unicode - SQL2000
184:
WITH (SUB QUERY) IN 2005
185:
Import CSV to table Part 2
186:
Joining from two different tables
187:
Help with Update, please
188:
SQL 2005 User DB Permissions
189:
many BULK INSERTs and error "cannot obtain a lock"...
190:
how to do databse testing for sqlserver
191:
Help with CASE statement
192:
Compare 2 Tables Using Multiple Columns
193:
SQL 2000 Datatable Default value question
194:
CDOSYS email body truncated
195:
sql 2k log files
196:
Database Name Environment Variable
197:
I have problems with connecting to a Instance from local Enterprise manager and from remote wih EM
198:
need some TSQL help
199:
Detach/Attach Via Management Studio
200:
Case statement in the WHERE clause
201:
SQLMail, @originator_address
202:
Table locking and Deadlocks
203:
restore db from network drive
204:
ADO and mutithreading...
205:
Help with Join
206:
Is this query possible?
207:
Offsetting data
208:
yet another out of control log file
209:
default constraint
210:
good perfmon counter
211:
MDAC Version ?
212:
SQL Mail with Outlook 2003 not finding profiles
213:
SP Debugging problem
214:
How can I generate insert statements for sample data?
215:
faster query than this
216:
is there a set-based solution to this task?
217:
Backup information
218:
SQL server performance
219:
18456 error-Help!
220:
MI5 Persecution: Leant On 7/4/96 (14671)
221:
Temporary directory
222:
RAID
223:
lose data
224:
Put Windows Logs into SQL
225:
Rounding problem
226:
SQL Server 2000 is only using one processor
227:
TRIGGERS
228:
RollBack Restore - Help!
229:
Hierarchies problem
230:
Trigger logic question - using If with AND and OR
231:
default path for input/output using isql/osql/isqlw
232:
Maintenance Plan
233:
32bit and 64bit binaries on 64bit Windows?
234:
What is "SQL Trace ID 2"
235:
Force a table to stay in memory?
236:
DB question
237:
help with query with computation
238:
JOB failed and QA
239:
SQL: Removing all spaces?
240:
inserting duplicate in unique index?
241:
SQL Server Reporting Services ?
242:
Inserting into 'ntext' columns
243:
VarBinary type conversion
244:
Create calculated column based on data
245:
Attach Question
246:
How can I trace all Stored Procedure calls?
247:
Database ID
248:
BCP
249:
Covered Index
250:
SQL can not view Network share
251:
Insert statement help
252:
Log shipping and Manual backups
253:
FULL and Tran Backup
254:
Could not find stored procedure problem on sql 2005
255:
Please Help: Someone is hacking my server!
256:
Killing system process
257:
Update problem.
258:
sp_attach_db Error
259:
Can SQL check foreign key constraint with uncommited read?
260:
data conversion problem - arithematic overflow
261:
Help with import
262:
Comparing two text datatype fields
263:
MSDE vs SQL Server Developer Edition
264:
Searching contents of stored procs
265:
collation error...
266:
Select column names + values in query analyzer
267:
C++ ADO Parameters problem
268:
Sp_addlogin from vb.net (security)
269:
Changing column type
270:
PATINDEX with special characters
271:
Backup/Restore vs Detach/Attach 2000 Databases to 2005
272:
Tuning query?
273:
Extracting index's as script
274:
Days falling in a certain period
275:
Insert Error: Column name or number...
276:
Logging
277:
Stored Procedure - wont auto start
278:
String propper case
279:
error msg on backup
280:
Cascading address returns in query
281:
Problem executing a stored proc, please help
282:
unique but allow nulls
283:
oledb to ibm db2 - no tables?
284:
possible to determine weekday with Tsql?
285:
Updating Tables
286:
Return length of the value (after the decimal places)
287:
DTS Packages using c#
288:
Enterprise Level Database
289:
Assigning a row number to each row (for pagination and browse)
290:
Error opening table in Windows 2003
291:
Partitions and Primary keys
292:
Unable to launch Activity Monitor (2005 -> 2000)
293:
table as an argument to a stored procedure
294:
How do i block SQL browse list?
295:
cannot start trace
296:
Index Errors!
297:
graemesmith1@youbanking.com
298:
Cannot access Report Manager
299:
Subqueried CASE statement