View Full Version : sql server answers


Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 [22] 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

  1. un-registering a server
  2. Question: Recording login access to SQL Database
  3. Error when setting up ODBC Connection
  4. Performance monitors
  5. Help with phoneBook db design
  6. Text datatype as local variables in Trigger
  7. Migrating to SQL 2003
  8. Adding Time Totals in SQL
  9. Why I can't drop a table
  10. query plan in clear text
  11. How to copy data from backup or data files to new SQL installation?
  12. dynamically trasnpose rows into columns
  13. Sync to databases nightly with BLOB data
  14. Strange FK relationship - how, and is it right?
  15. maintenace plan question please
  16. Deadlocks and Parallel Query Processing
  17. SQL Debugging Tool
  18. Export Data from SQL Enterprise to SQL Express 2005
  19. *=
  20. 1 question about psql table
  21. Please help the performance issue.
  22. When Linking A Server; Only System Tables Are Accessible!
  23. Database security (crosspost)
  24. Database security
  25. datetime
  26. Help with blocking on querying two joined tables
  27. XOR and foreign key constraints
  28. Toad & S2K5
  29. Transactional Replication
  30. SQL relationships and identities
  31. listing SQL Server databases on a network
  32. Disabling Constraint for Bulk Loading
  33. How to Load SpreadSheet in AxSpreadSheet object in VB.NET or C#.NET
  34. Regarding Index Rebuilding
  35. Help with SQL Query !
  36. Role/Person Table?
  37. Should I worry
  38. Concatenation Limits in SQL Server 2000?
  39. Reporting Services
  40. fix for long running transaction problem
  41. Help with select query
  42. Lock table problem
  43. Need Material for "Sybase to Sql Server Migration"
  44. Replication of several satellites into one central db: adding location key ?
  45. Query Optimization: CPU speed or Logical Reads better?
  46. Query Optimization: CPU speed or Logical Reads better?
  47. Using muliple smaller SPs and Functions better than using 1 big SP?
  48. Nested Nodes in XML from a table
  49. Compile/combine the contents of several records.
  50. Is this an efficient way to create a comma string
  51. Excel file import problem
  52. MSE
  53. Get previous record
  54. help with grouping query...
  55. User Loggon Password Changed
  56. 1 SP with dynamic input parameters and multiple rows as the source of the query
  57. Nested Triggers
  58. Getting data from multiple rows into one column
  59. SP and ADO Page Property Not Working Properly
  60. SLEEPING/AWAITING COMMAND question
  61. error handling and bulk insert
  62. Inserting dummy lines and padding
  63. Planning multiple queries
  64. Mini Index?
  65. Select *
  66. cannont create SSPI context (SQL connection problem after 30 minutes)
  67. Databases not showing up in Enterprise Manager
  68. upgrading to SQL 2005
  69. Help needed by deadlock problem
  70. Can REPLICATION on SQL Server 2000 allow dirty reads
  71. 2000 Replication with DB in 65 Compatibility Mode
  72. Application & Database Security Consultant
  73. Can I install VS.net 2005 / VS.net 2002 / SQL 2005 / SQL 2000 in one PC win2000 sp4?
  74. Why upgrade to MS SQL Server (be it 2000 or 2005) from Access (say, 97)?
  75. Extracting and joining header from denormalized table
  76. HELP: Strange Blocking Performance Problem with Simultaneous Queries
  77. Indexing and Queries
  78. problem creating DTS package
  79. splitting a string
  80. Help needed with query syntax
  81. Clustered versus Create table on high speed FILEGROUP
  82. big log file
  83. String case problem
  84. accessing mssql in linux through c++ code
  85. Index Design Recommendation - Examine Column Uniqueness
  86. Index Design Recommendation - Examine Column Uniqueness
  87. PAGEIOLATCH is a lead blocker
  88. Query question
  89. Monitoring replication
  90. Wildcards On Columns?
  91. Show owner of database
  92. Temp Table and SP Advise
  93. Subtracting two columns from diff tables
  94. LOAD .SQL file
  95. Regarding BCP utility
  96. STORED PROCEDURE - passing table name as a parameter
  97. Passing DateDiff rather than Actual Dates as Parameters
  98. log shipping
  99. Problem with spid by sp_who
  100. Format() Function in MS SQL
  101. Select into / Linked Server / Missing IDENTITY attribute
  102. SQL errors, trapping in Server Agent
  103. multi-field primary key
  104. Bulk Import with header in text file
  105. Data grouped by 20 minutes?
  106. About: An INSERT EXEC statement cannot be nested.
  107. CASE problem
  108. An INSERT EXEC statement cannot be nested error.
  109. Strange Performance question
  110. Can't send operator email in SQL Sever 2005
  111. sql 2000 64-bit
  112. Return pkID of last saved record - ASPUpload & @@Identity
  113. connection TCP/IP through the port 1433
  114. Microsoft SQL 2000 Documenter
  115. Using the copy database wizard
  116. Timeout Period in SQL Server 2005
  117. SQL View Performance
  118. Bulk delete on operational data
  119. Performance when using php and mysql
  120. Query Retrieval is slow
  121. Oracle licensing for dual core processors
  122. SQL backup - dun understand
  123. Prepared SQL Plan vs. Procedure Plan
  124. difficult summing query
  125. SQL Query Help
  126. SQL server - script execution time
  127. Subquery headache with Count and GroupBy
  128. query problem
  129. 100 % CPU Usage
  130. How to move two separate databases into one?
  131. Combining INTO with UNION
  132. Enterprise Manager - problem
  133. Tuning API CURSORS
  134. How to drop one of the tempdb files
  135. SQL Equivalent of MAX and IIF
  136. Need help with Count function and temporary tables
  137. Limit saving DTS package to SQL Server
  138. batch replication
  139. problem with Select query
  140. About bcp_init
  141. Scheduled Job Hangs the server
  142. Active directory and SQL 2K
  143. Scheduled job hangs the server
  144. Compressed folder & Query speed
  145. UBOUND
  146. Recordset
  147. Requirement : IBM Process Choreographer
  148. Hiding secret columns from users
  149. Splitting a filename out of a filepath
  150. verify if database exists
  151. SP 4 error
  152. BULK INSERT and APPLICATION ROLE
  153. About dtsrun
  154. Database Problem related Clusterd data
  155. need a DBA Suggestion.
  156. Make a Bunch of Rows from a Table Resemble a Column
  157. Simple SQL Query (To Neglect time from DateTime DataType)
  158. Alex
  159. Log Invalidated after truncate table
  160. stored procedure with array of parameters
  161. HIT and MISS
  162. SQL Server Msg 1105, Level 17, State 2, Line 1
  163. Query returning 1.7million records slow
  164. Best use of inner join
  165. Is this normal
  166. What looks like a basic SQL query still not resolved
  167. Inner join weirdness in DTS
  168. exam ms 70-228
  169. need help
  170. Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
  171. Creating WHERE clauses based on IF (or CASE) STATEMENTS Transact-SQL
  172. Optimizing Stored Procedure with Datetime parameter
  173. SQL statement to compute employee pay for a year at different pay rates
  174. adding identity column dynamically
  175. need information on SQL SERVER 2000 with multi-threading CPU
  176. sql query update
  177. There is a question when i work on Linkedserver~Pls kindly help me:)
  178. full text catalog on remote (shared) server
  179. Merge Replication - Adding a new table
  180. QUESTION: Connecting with SQL Admin across domains
  181. Indexes being improperly used when selecting data through a view
  182. SQL-Server DBA-Full Time, Permanent, National Institutes of Health
  183. Optimal search for the nearest date
  184. get the DB index SQL
  185. NEWID()
  186. SQL 2005 Unhandled Exception Error
  187. SQL 2005 Developers Diagram question
  188. flexible back-end data handling in .net + sql project
  189. Query Question
  190. Options to upgrade an SQL 6.5 DB to 2000
  191. DTS package design - Not allaowed link
  192. Is DTS source file's name parameterizable?
  193. Tracking Package Execution Status
  194. Install or not to install Launch Give away version?
  195. Room availability
  196. Concatenating strings from different rows
  197. who knows reporting service
  198. SQL Join with unknown tables - but it works!?!
  199. Star Join
  200. why the MS DTC always stop services automatically ?
  201. SQL server connection problem
  202. working with large numbers
  203. regarding BLOB
  204. How to delete data older than X days, without considering time
  205. Something Basic
  206. Something Basic
  207. Store data horizontally or vertically?
  208. Need security advice on xp_cmdshell, bcp, xml procedure
  209. Linking a table
  210. Simpleton question please
  211. migrating form standard to enterprise edition
  212. how to have the DB diagram
  213. Parse Return value of SYSTEM_USER
  214. DBGEN TPCH Compiling
  215. How to do a JOIN statement for a table with 2, one-to-many relationships.
  216. Bulk Delete
  217. Help with SQL query
  218. Terminal Service cause TimeOut Expired
  219. QUESTION: No Support for SQL 2K on W2K3??
  220. Database optymalization(??)
  221. Filegroup restore problems
  222. Where are the maintenance plans stored in SQL Server 2005?
  223. stored procedure update HUGE PROBLEM
  224. grouping select query
  225. Tables in Parent-Child order
  226. DTS question: 2 source tables, 1 target, 3 connections
  227. Question about Views and sp_refreshviews
  228. Interesting SQL query requirement for <SELECT> menu
  229. Insert
  230. update spends 1800 times more than select
  231. Sql Server 2000 causing TCP/IP to crash?
  232. optional parameter in sql query
  233. commit and rollback problem
  234. tree structure select problem
  235. OpenDataSource trouble with Advantage SQL
  236. newby - AUTOINCREMENT problem.
  237. is WITH ENCRYPTION now safe in SQL2005?
  238. Return Stored Procudure Values
  239. MDF File Still Exists After DROP TABLE
  240. stored procedure
  241. DELETING 100 million from a table weekly SQl SERVER 2000
  242. row level security across multiple columns
  243. BlackBerry Enterprise Server - SQL problem
  244. an unexpected error occured during this operation
  245. mirrored sql servers
  246. How can I tell if a sql server is MSDN or Standard or Enterprise version
  247. sysprocesses memusage sleeping
  248. access MS SQL/ACCESS from linux?
  249. TCP/UDP ports used for Index server OpenQuery
  250. aggregate question
  251. Looking for an opinion
  252. help
  253. Using Query Analyzer with Windows Auth across domains
  254. Whats wrong with my join statement?
  255. Approximate String Searches
  256. Pros / Cons to this approach
  257. learning Microsoft Query Analyzer
  258. Automatic SQL Queries to dump data to folder
  259. Updating a Chunk of data without crashing transaction log
  260. Tables are skipped or export failed error occurs when upsizing MS Access to MS SQL Server
  261. Default charset in sqlserver 2000? / jtds
  262. History of logins or Userids
  263. TPC -H creation script
  264. Torn Page
  265. Is there any REGEXP library for TSQL?
  266. Database design question...
  267. host_name
  268. SQL query question
  269. Unique Constraint on Multiple columns
  270. Stored Procs and db_owner
  271. Information Schema Query Question
  272. Passing authentication from PHP to reporting services
  273. Possible to keep MS Access interface and migrate the MS Access to MS SQL Server?
  274. Mira Laura, toma la direccion web,,, dime algo. MS58
  275. Rendering directory structures
  276. question about log file size when alter Huge table
  277. Use DEFAULT CONSTRAINTs or BOUND DEFAULTs?
  278. Problem with HOST_NAME Function with Linked View
  279. Creating Tables on the Fly
  280. have sql file and want to run it on an ftp connection
  281. unique constraint to a column from another table
  282. DTS Table Import Issue
  283. error message 18542 level 16 state 1
  284. Count(*) Locking up things ...
  285. Distinct Filter in SQL Reporting Services
  286. Multiserver Administration
  287. MSDE and two instances on the same server?
  288. Attaching MDF without LDF
  289. Statement for returning stored procedure params
  290. SQL Server 2000 and 8k limit
  291. advice needed on new server product
  292. Find the Data Bases which can not be Backed up are some resons
  293. Find the Data Bases which can not be Backed up are some resons
  294. String manipulation challenge in SQL
  295. Table Synchronization across databases on the same server
  296. How to take data out of table, restructure the table and then put the data back in
  297. DTSRun causes The Memory could not be "read" application error
  298. Server Listing for TCP connection
  299. Identical database w/ identical stored procedures?
  300. Record , Row number
  301. Record , Row number
  302. Deriving unique rows from historical data
  303. too many connections
  304. User Defined Functions, passing parameters from another udf's results (end result=Crosstab)
  305. Tool for clients
  306. Stripping Punctuation
  307. Create Procedure Output ntext
  308. need to replace replication server with main server
  309. DAO > SQL Server Processes
  310. How to select data
  311. Quarterly trending
  312. Quarterly trending
  313. excluding fields in SELECT statement
  314. mssql ide (front ide)
  315. SQL Server 2000 Error 17805 Invalid buffer received from client
  316. Many data entry tables - which ones hold records?
  317. CAST Command
  318. EnterpriseManager-->Process Info Screen
  319. How to create table names by using macro variable? Thanks!
  320. Sql Server 2005: Get a list of all configured Web Services in the "Object Explorer"
  321. historical data
  322. How do I concatenate text to a sql statement
  323. Table Documentor
  324. DTS vs triggers
  325. Synchronising access and sql server
  326. I wish upon a new server ....
  327. Problem with simple cursor
  328. Foreign and primary keys
  329. Adding an auto-increment column to existing table with a particular order
  330. Derived tables from multiple resultsets
  331. MOM blocking analysis
  332. sum of sums
  333. Identifying results sets when stored procedure called multiple times
  334. simple userdefined function question.
  335. Unable to update view in Sql Server 2000
  336. A way to recursively look up hierarchal data using a lookup table
  337. How is inheritence like data best done in SQL
  338. .dat
  339. Certification is not so easy job.
  340. Query help
  341. Moving Data for Audit - Best Practice
  342. Sequence of columns in primary key
  343. How to display just user defined objects?
  344. Creating Primary key with ODBC
  345. Form Slow, Then Fast
  346. SQL UPDATE - PLEASE HELP
  347. Database Access over Internet
  348. How to Interpret Merge Agent History and Session Detail
  349. determine tables that are Simple recovery
  350. Organization tree
  351. MS SQL Server 2000 - Search a table with 300,000+ records in less then a second or two
  352. Wrong default constraint shown from Object Browser in Query Analyser
  353. Tracking user activities
  354. Column By Column Comparison
  355. Relational Database Usage survey
  356. Unique Selections In Back End
  357. Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
  358. Using "SELECT * " is a bad practice even when using a VIEW instead of a table?
  359. Type Mismatch Error On Bulk Insert
  360. Overflow error
  361. Defragment Heap Tables
  362. Bulk insert
  363. Bulk Insert Command
  364. Update One Based on ANother Table
  365. Help with Query
  366. Is logging the execution time of Stored Procedures with standard settings possible?
  367. registering SQL Server not in domain
  368. Problem with SUM
  369. Join statement
  370. Changing the 6th character of a string?
  371. Bulk Insert Data in Millions - Lock Issue
  372. AutoNumber vs. Key
  373. Any way to optimise this query?
  374. embedded control characters
  375. Errors with SP4 upgrade... Please Help
  376. One-One Relationship
  377. ...Contains more than the maximum number of prefixes. The maximum is 3.
  378. Template function
  379. Sql Server backup vs HP Data Protector (HPDP) -- Do *not* use SQL Server?
  380. LIKE and IN can I combine
  381. database in simple mode yet txn log file can be out of diskspace ?
  382. selecting only the last record in joined table
  383. Sooper Newb Ques: Starting with SQL Server 2000 DE
  384. Schema Diff Tool
  385. Dates in a date range
  386. Temp Table on Linked Server
  387. PK and Timestamp in same table?
  388. Backup for one new DB failing in regular maintenance job Error 3201
  389. SQL Import of LArge Amount of Data
  390. question about like
  391. OpenRowSet with Excel DENIED
  392. SQL Convert function!!
  393. changing indexes
  394. SQL for field names from a table
  395. Change Data Type
  396. seeing FMTONLY/NO_BROWSETABLE ON stuff in the profiler
  397. Import cell data from XLS into SQL table
  398. Please suggest backup software
  399. delete of mirrored rows
  400. Joins: strategy and how-to approach
  401. Unique ID added to a result set
  402. how to determine programatically what output of a sp will be?
  403. Display Money Type using + and -
  404. image data type
  405. Transaction Management
  406. resultset of proc in another proc
  407. new sql version control solution!
  408. Search Advice
  409. PostgreSQL Linked Server question
  410. OPENXML vs BCP
  411. my new function not found
  412. Error installing SQL Server2000: A previous program installation created pending file operations on the installation machine
  413. word xp
  414. Calling a Data Pump task from DTS?
  415. copying server objects
  416. Can't "SELECT" using CREATED_DATE column...help
  417. Multiple level nested Corelated query
  418. Problem with case expression
  419. jacek@karczmarczyk.pl
  420. Error handling when calling external sql-Files
  421. Trouble with SPROC
  422. Unit Testing
  423. Autogrow question
  424. Need help formulating a query
  425. ASP.NET + SQL 2005
  426. Query Help, thanks!
  427. How to save DTS package as an application
  428. How to convert from CHAR to Numeric in the table
  429. Horizotal to Vertical Display
  430. How to check Backup of SQL Server Database
  431. Controlling fields in a select statement by use of parameters
  432. NAMED SET / PIVOT TABLE !! HELP ME
  433. Howto set Access Recordsource onto a "select" sproc
  434. HELP MDX , NAMED SET AND PIVOT TABLES !!
  435. SQL Server 2000 Backup + Restore question
  436. SQL Mail setup
  437. SA can not create users
  438. Multiple entries script...help
  439. Database Replication
  440. Transaction log ???
  441. Problem causing me to have to restore tlogs WITH MOVE
  442. Restoring a missing db
  443. Job invoked by Alert but Alert never occured
  444. Fast Date Ranges Without Loops In SQL Server 2000
  445. Howto setup my user in order to grant him the drop privilege
  446. Performance and second table
  447. How to remove MSDE manually?
  448. Can I speed up this script...help?
  449. Stopping Query Execution from PHP
  450. Simple question
  451. Does DBCC DBREINDEX update stats?
  452. Consolidating Records
  453. Finding the most recient datetime
  454. ordering an int column
  455. SQL Server Hanging
  456. date format
  457. Access Control List (structure) invalid - updating Virtual directory information
  458. parsing varchar fields
  459. iSQL - Blank line at the end of the iSql output file
  460. Error : Difference of two datetime columns caused overflow at runtime.
  461. Error : Difference of two datetime columns caused overflow at runtime.
  462. The SMTP Server in xp_smtp_sendmail
  463. Blocking and Transactions OK?
  464. bit off topic: street name database US
  465. Report Services
  466. SQLColumns crash (Access violation)
  467. updating multiple fields
  468. Howto Format a string in a sproc ?
  469. Connecting Trace info to blocked users?
  470. PASS User Group Austria looking for MS-SQL professionals to take part
  471. Is there a way to find growth in log (ldf) and database(mdf) ?
  472. Any way to find out which SP is updating data in a specific table?
  473. min(date) + 1
  474. searching a list of tables, derived from another table
  475. XP and Replication
  476. Help finding the top 3 zipcodes within the top 5 counties
  477. Syntax to add records if primary key = list
  478. Renaming a Server
  479. Is there any way in a sproc to LOOP thru the records of a table ?
  480. inline if
  481. search on concatenated fields in sql server
  482. Original Data and Log size
  483. Rejoining replicating servers
  484. MDF / LDF
  485. Data Load Query
  486. Linked server
  487. Dynamic data elements for a data collection application
  488. Security Admin on a server with NO public permissions
  489. delete records
  490. bcp header
  491. Delete relationship?
  492. Insert based on a select query
  493. DataDirect Technologies Releases DataDirect XQuery to Simplify XML and Relational Data Integration
  494. Single quote in NVARCHAR string?
  495. How to update 1000s of items in 50 tables
  496. Identity...I need to get the last (or highest number in Identity column)...
  497. Stumped by SQL challenge
  498. SQL Server paged recordset problem
  499. SQL 2000 installation on WinXP Pro problems
  500. Can't connect
  501. Scheduling Database - Design Help!
  502. Scheduling Database - Design Help!
  503. Reg Exp for digits
  504. Converting Binary Image to Readable Text
  505. IDENT_CURRENT and empty table
  506. NOLOCK and READPAST on same table?
  507. Determine fastest query in Query Analyzer
  508. Using IS NOT NULL on column result from subquery
  509. Query Syntax help
  510. Aliased column in stored procedure not seen by datagrid
  511. SQL Mail - MAPI profiles on Windows Server 2003
  512. Best way to tell if a SP is a query Programatically
  513. Tools for design recovery (reengineering) of C# source code with embedded sql statements ?
  514. Extremely Slow Table
  515. how to do text replacements
  516. SQL Server bouncing connections
  517. Dont backup if Database hasnt changed
  518. The "right" way to distribute a database to end-user
  519. Why dosn't IIF work here?
  520. saving output from multiple queries
  521. Can someone help me with multiple "Left Outer Joins"?
  522. Can someone help me with multiple "Left Outer Joins"?
  523. Need Help with "Left Outer Join"...
  524. Removing white spaces in a varchar column
  525. Help on a SQL query
  526. oracle pl/sql -> sql server
  527. Index corruption on table without key: what could be the reasons ?
  528. SCOPE_INDENTITY() Not Returning
  529. Script to search for a string in all varchar columns in all tables in a database?
  530. VB 6 & SQL Database: How can I create reports with charts ?
  531. Saving query plan
  532. Output stored procedures as text problem
  533. XML generation issues
  534. How to count
  535. How to override zero rows returned
  536. Monitoring Software
  537. xp_sendmail problem - body message breaking onto new line..
  538. Find the Stored procedure
  539. Round problems in SQL 2000
  540. Changing From Windows To Mixed Authentication
  541. sql datatype help
  542. Systematically determine DRI problem(s)
  543. Any SELECT Statement Gurus Out There?
  544. Import Spreadsheet error
  545. How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log
  546. desinstall MS SQL
  547. XML Tables generation
  548. desinstall MS SQL
  549. Help with calling a job from Stored P and VBA......HELP
  550. About adding a new column...